CARTESIAN JOIN
Short Description
A join without join conditions. Every row in one data source is joined with every row in the other data source. This creates a Cartesian product.
Where to use​
A cartesian join is used where you want to join every row in one table to every row in another. An example of using this would be to combine a list of students and a list of courses to add every student to every course.
The number of rows in the output will be [tab1 rowcount] x [tab2 rowcount]
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.